package com.person.jc.common;

public class SQLSpell {
	
	/*
	 * 设备名称
	 */
	public static String deviceName(String device_id){
		return "select device_name from bd_device_info where device_id = " + device_id;
	}

	/*
	 * 数据字典，类别名称
	 */
	public static String kindName(String type_code, String kind_code){
		String sql = "select kind_name from ts_code_kind_data where kind_code = "+kind_code+" and type_code = '"+type_code+"'";
		return sql;
	}
	
	/*
	 * 用户单位名称
	 */
	public static String customerName(String custId){
		String sql = "select cust_name from bd_customer where cust_id = " + custId;
		return sql;
	}
	
	/*
	 * 用户名称
	 */
	public static String userName(String userId){
		String sql = "select user_name from ts_user where user_id = " + userId;
		return sql;
	}
}
